A rare investment opportunity! Discover 140-142 Query St in New Bedford, MA, an exceptional 6-family property offering an expansive 6414 sq ft of living space w/ 12 bedrooms & 6 bathrooms. This building is in pristine condition; in fact, contractors who have worked on the property describe it as "Mint," "A Cadillac," & the "Nicest Multifamily they have ever seen." The mechanicals are significantly upgraded: 4 units feature gas hot water baseboard heat, while the two 3rd-floor units are equipped w/ forced hot air. The exterior has been meticulously maintained, featuring a roof replacement in Dec 2013, plus low-maintenance vinyl siding & new gutters installed in 2022.This property is a true standout for investors. It boasts a massive 54-panel solar system producing over 18,000 kWh annually, offering incredible energy efficiency. Outside, you'll find a patio out back, a storage shed for extra space, & a 2-car garage that is split & separately rented for additional income. Location is a major plus: situated just minutes from the highway & only a 2-minute ride to the new Church St Commuter Rail station, making it highly attractive for commuters. Don't miss your chance to add this premier, turn-key asset to your portfolio!